#!/bin/sh
echo 'analysis user click。。。'
currDate=`date +%Y-%m-%d`
echo "现在时间：'$currDate'"
/opt/lagou/servers/hive-2.3.7/bin/hive -e "USE mydb;INSERT INTO TABLE user_info SELECT COUNT(DISTINCT id) active_num, TO_DATE(click_time) dateStr FROM user_clicks  GROUP BY TO_DATE(click_time);"
